/*
 Navicat Premium Data Transfer

 Source Server         : localhost_8.0
 Source Server Type    : MySQL
 Source Server Version : 80031
 Source Host           : localhost:33060
 Source Schema         : django-it-community

 Target Server Type    : MySQL
 Target Server Version : 80031
 File Encoding         : 65001

 Date: 26/03/2025 21:29:59
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for auth_app_user
-- ----------------------------
DROP TABLE IF EXISTS `auth_app_user`;
CREATE TABLE `auth_app_user` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `password` varchar(128) NOT NULL,
  `last_login` datetime(6) DEFAULT NULL,
  `is_superuser` tinyint(1) NOT NULL,
  `username` varchar(150) NOT NULL,
  `first_name` varchar(150) NOT NULL,
  `last_name` varchar(150) NOT NULL,
  `is_staff` tinyint(1) NOT NULL,
  `is_active` tinyint(1) NOT NULL,
  `date_joined` datetime(6) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `ava` varchar(200) DEFAULT NULL,
  `sex` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_app_user
-- ----------------------------
BEGIN;
INSERT INTO `auth_app_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `is_staff`, `is_active`, `date_joined`, `phone`, `email`, `ava`, `sex`) VALUES (1, 'pbkdf2_sha256$720000$4l8r5eqw4Kda1lj62o9VB7$Aaib3+6XEf4XWHWKsXs1DGgyB2pUcWcdUSPzIQfZvN4=', '2025-03-26 21:27:28.159999', 1, 'admin', 'admin', '', 1, 1, '2024-03-04 10:36:08.091170', '1234567890', '1411@qq.com', '33e0b72b-f56b-41f5-a724-8fa3d022eedc.png', 1);
INSERT INTO `auth_app_user` (`id`, `password`, `last_login`, `is_superuser`, `username`, `first_name`, `last_name`, `is_staff`, `is_active`, `date_joined`, `phone`, `email`, `ava`, `sex`) VALUES (2, 'pbkdf2_sha256$720000$4l8r5eqw4Kda1lj62o9VB7$Aaib3+6XEf4XWHWKsXs1DGgyB2pUcWcdUSPzIQfZvN4=', NULL, 0, 'user1', '爱吃青菜', '', 0, 1, '2024-03-11 09:06:16.289771', '12345678900', '1411@qq.com', NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for auth_app_user_groups
-- ----------------------------
DROP TABLE IF EXISTS `auth_app_user_groups`;
CREATE TABLE `auth_app_user_groups` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `group_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_app_user_groups_user_id_group_id_5f174ff0_uniq` (`user_id`,`group_id`),
  KEY `auth_app_user_groups_group_id_b4576925_fk_auth_group_id` (`group_id`),
  CONSTRAINT `auth_app_user_groups_group_id_b4576925_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
  CONSTRAINT `auth_app_user_groups_user_id_2b6e45f5_fk_auth_app_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_app_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_app_user_groups
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_app_user_user_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_app_user_user_permissions`;
CREATE TABLE `auth_app_user_user_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `user_id` bigint NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_app_user_user_permi_user_id_permission_id_727a8e97_uniq` (`user_id`,`permission_id`),
  KEY `auth_app_user_user_p_permission_id_cc1b2396_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_app_user_user_p_permission_id_cc1b2396_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_app_user_user_p_user_id_b7c37328_fk_auth_app_` FOREIGN KEY (`user_id`) REFERENCES `auth_app_user` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_app_user_user_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_group
-- ----------------------------
DROP TABLE IF EXISTS `auth_group`;
CREATE TABLE `auth_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_group
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_group_permissions
-- ----------------------------
DROP TABLE IF EXISTS `auth_group_permissions`;
CREATE TABLE `auth_group_permissions` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `group_id` int NOT NULL,
  `permission_id` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
  KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`),
  CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
  CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_group_permissions
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for auth_permission
-- ----------------------------
DROP TABLE IF EXISTS `auth_permission`;
CREATE TABLE `auth_permission` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `content_type_id` int NOT NULL,
  `codename` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`),
  CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of auth_permission
-- ----------------------------
BEGIN;
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (1, 'Can add log entry', 1, 'add_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (2, 'Can change log entry', 1, 'change_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (3, 'Can delete log entry', 1, 'delete_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (4, 'Can view log entry', 1, 'view_logentry');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (5, 'Can add permission', 2, 'add_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (6, 'Can change permission', 2, 'change_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (7, 'Can delete permission', 2, 'delete_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (8, 'Can view permission', 2, 'view_permission');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (9, 'Can add group', 3, 'add_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (10, 'Can change group', 3, 'change_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (11, 'Can delete group', 3, 'delete_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (12, 'Can view group', 3, 'view_group');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (13, 'Can add content type', 4, 'add_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (14, 'Can change content type', 4, 'change_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (15, 'Can delete content type', 4, 'delete_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (16, 'Can view content type', 4, 'view_contenttype');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (17, 'Can add session', 5, 'add_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (18, 'Can change session', 5, 'change_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (19, 'Can delete session', 5, 'delete_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (20, 'Can view session', 5, 'view_session');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (21, 'Can add user', 6, 'add_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (22, 'Can change user', 6, 'change_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (23, 'Can delete user', 6, 'delete_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (24, 'Can view user', 6, 'view_user');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (25, 'Can add captcha store', 7, 'add_captchastore');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (26, 'Can change captcha store', 7, 'change_captchastore');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (27, 'Can delete captcha store', 7, 'delete_captchastore');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (28, 'Can view captcha store', 7, 'view_captchastore');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (29, 'Can add article', 8, 'add_article');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (30, 'Can change article', 8, 'change_article');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (31, 'Can delete article', 8, 'delete_article');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (32, 'Can view article', 8, 'view_article');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (33, 'Can add notice', 9, 'add_notice');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (34, 'Can change notice', 9, 'change_notice');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (35, 'Can delete notice', 9, 'delete_notice');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (36, 'Can view notice', 9, 'view_notice');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (37, 'Can add type', 10, 'add_type');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (38, 'Can change type', 10, 'change_type');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (39, 'Can delete type', 10, 'delete_type');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (40, 'Can view type', 10, 'view_type');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (41, 'Can add collect', 11, 'add_collect');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (42, 'Can change collect', 11, 'change_collect');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (43, 'Can delete collect', 11, 'delete_collect');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (44, 'Can view collect', 11, 'view_collect');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (45, 'Can add follow', 12, 'add_follow');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (46, 'Can change follow', 12, 'change_follow');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (47, 'Can delete follow', 12, 'delete_follow');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (48, 'Can view follow', 12, 'view_follow');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (49, 'Can add message', 13, 'add_message');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (50, 'Can change message', 13, 'change_message');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (51, 'Can delete message', 13, 'delete_message');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (52, 'Can view message', 13, 'view_message');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (53, 'Can add comment', 14, 'add_comment');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (54, 'Can change comment', 14, 'change_comment');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (55, 'Can delete comment', 14, 'delete_comment');
INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES (56, 'Can view comment', 14, 'view_comment');
COMMIT;

-- ----------------------------
-- Table structure for captcha_captchastore
-- ----------------------------
DROP TABLE IF EXISTS `captcha_captchastore`;
CREATE TABLE `captcha_captchastore` (
  `id` int NOT NULL AUTO_INCREMENT,
  `challenge` varchar(32) NOT NULL,
  `response` varchar(32) NOT NULL,
  `hashkey` varchar(40) NOT NULL,
  `expiration` datetime(6) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `hashkey` (`hashkey`)
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of captcha_captchastore
-- ----------------------------
BEGIN;
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (1, 'KHSS', 'khss', '57a6722ca75c0387644a8155d739683ab18a7282', '2024-03-04 13:11:53.360907');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (2, 'AJUF', 'ajuf', '25f409392b738224a1411d6ebf1801679e6e9619', '2024-03-04 13:12:26.330763');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (3, 'QFZP', 'qfzp', 'aaabb3e6990c6c1fab3995c5659d60244abf1228', '2024-03-04 13:12:40.243019');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (4, 'JMSR', 'jmsr', '0bf7898cea826ade15f52a3a5fc0d0d3a5dce98d', '2024-03-04 13:12:53.507499');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (5, 'FJYU', 'fjyu', '763c99e9984491a030b69d10995d8e950735b88c', '2024-03-04 13:13:03.599496');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (6, 'HMQG', 'hmqg', '384f38dae2dedd44b205d065a0e12418d51b5f68', '2024-03-04 13:13:58.058870');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (7, 'NQJU', 'nqju', '8def040300ad1557aa74b9659e4d7aeace78b6b0', '2024-03-04 13:14:01.961249');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (8, 'FHEO', 'fheo', '17662e4ac96d71549e3bf00ecaa6353efa93438c', '2024-03-04 13:14:44.191785');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (9, 'OQJA', 'oqja', 'd548632e4c266997c3cf862df3fbad10b925af30', '2024-03-04 13:14:58.279350');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (10, 'QFBX', 'qfbx', '566e6d1638aea2756d0b23883bd5805390dad68c', '2024-03-04 13:15:21.839699');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (11, 'KSII', 'ksii', '34eb1cd2082467ba086ae6b9d7bf83178f06edcf', '2024-03-04 13:15:35.496975');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (12, 'CDEB', 'cdeb', '5a5961f41ae93902a167de193d254c91a59c77fa', '2024-03-04 13:15:51.765764');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (13, 'YFUG', 'yfug', '9802c27e829b4a05058746ca2a3a4487b6ae8c1c', '2024-03-04 13:15:55.581943');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (14, 'CYDV', 'cydv', 'a4763bd2aa9dd47b230de8acc90c4105a45cc7e3', '2024-03-04 13:16:43.034494');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (15, 'DJZZ', 'djzz', '5de989fd822a743894f397975805b99522e2c0c6', '2024-03-04 13:16:48.086674');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (16, 'YCMD', 'ycmd', 'e4e126f5260e69d22516fa4a4acc2bf196b7b1ef', '2024-03-04 13:16:54.239916');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (17, 'GBCO', 'gbco', 'c9f480cbda3d612cdc1bbc0a4ea6b4b5eb1c556e', '2024-03-04 13:17:07.062441');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (18, 'UANL', 'uanl', '7fbeb59a05017fdd0d6b296bd79bbfad98401237', '2024-03-04 13:17:23.561577');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (19, 'STFR', 'stfr', 'f0b753642e7beb3cc8ec3ef2c1161f5385234b5a', '2024-03-04 13:18:10.575019');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (20, 'TYKE', 'tyke', '5722017af348c1834704e059eaea946983ace18f', '2024-03-04 13:18:35.418418');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (21, 'VCNF', 'vcnf', '289ddcd214ca381ec422676cb8cdb42202f7afbe', '2024-03-04 13:19:12.642033');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (22, 'DESH', 'desh', '4c7486809a267a4fd77c48093b893b45c6308f79', '2024-03-04 13:19:40.873952');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (23, 'ATKS', 'atks', 'f85066248ce21f6c13b4a0647845aba60f9c5fe2', '2024-03-04 13:20:08.925400');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (24, 'VAHF', 'vahf', 'd1b829cf1009c55c72080c34e9076fef957b9ba3', '2024-03-04 13:22:31.092701');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (25, 'XDJO', 'xdjo', '2afebe690a67d08a6704ff49e04d1c39321431e6', '2024-03-04 13:22:59.810788');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (26, 'MMWW', 'mmww', '4ea08c1f2175403f5aee60bdd88dab3be5cbc76a', '2024-03-04 13:23:03.377648');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (27, 'QDWP', 'qdwp', 'f730f650f49fe2ff9312c6b74cce44acd94a14dc', '2024-03-04 13:23:07.302719');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (28, 'DKPK', 'dkpk', '85114b05351c964eb8d5b54d8de6fe4ed1ec6352', '2024-03-04 13:23:36.375247');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (29, 'QLTW', 'qltw', '2eeaa95580dc8c694fd1586bbde225c4dec1d0d8', '2024-03-04 13:23:42.903866');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (30, 'GEJM', 'gejm', 'd1c5a727467dcf479309099df3e82412db5138e3', '2024-03-04 13:24:04.764007');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (31, 'LLJD', 'lljd', '1a9e690685da6eb8ff7bc653bf9fd6775562981d', '2024-03-04 13:24:07.155716');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (32, 'NMUA', 'nmua', 'd28d072762c8fa8a903d2a67b5a47451465f5531', '2024-03-04 13:24:09.033253');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (33, 'LBUT', 'lbut', '08546706a3a6181dce4a17b15517c9cb4b01225b', '2024-03-04 13:24:12.882321');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (34, 'ERVV', 'ervv', '3ac813ea310f8cc2537faf3c14cb361f969fd52b', '2024-03-04 13:24:19.868413');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (35, 'KXVV', 'kxvv', '2f7c9819342a5a53fb349be8ff654f13df1dbeee', '2024-03-04 13:24:28.035266');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (36, 'NJND', 'njnd', '45dff1da191d047815ccc0de98a275b7bf52de47', '2024-03-04 13:26:23.924354');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (37, 'ISAO', 'isao', 'f9819a8a15b2390169ede8be6310c08caa7892d2', '2024-03-04 13:26:27.052531');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (38, 'AHCY', 'ahcy', 'd74898ab36de7671468c39d94bcdc3cd327eca93', '2024-03-04 13:26:30.036571');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (39, 'UBTI', 'ubti', 'c85f7b6902d3ea40f270ec8b981f3a267e3f4859', '2024-03-04 13:26:36.395558');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (40, 'MTOM', 'mtom', '0b55d9614e9aa11db343bbd414b75b8428368c10', '2024-03-04 13:27:09.870026');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (41, 'SQMR', 'sqmr', 'c2813b4aa677bff1a363d9093520987d6043ebf3', '2024-03-04 13:28:40.083162');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (42, 'GSFQ', 'gsfq', 'bb66fc3ab4c40d7018ff615978ea649783630423', '2024-03-04 15:25:02.623613');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (43, 'BHWP', 'bhwp', '05f3cb54e88f2faa6db27aebf7a11f49389d94d6', '2024-03-04 15:25:55.212985');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (44, 'OJIP', 'ojip', '3b961df943ddfea322e75cfa8115d3c3d2bfd4a4', '2024-03-04 15:26:05.485189');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (45, 'NWNN', 'nwnn', 'd03f8a00bb541f770bcc4a0a41cda85b31fa3859', '2024-03-04 15:26:06.681365');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (46, 'VZRH', 'vzrh', '5ac9e8fa222db799c161c37c4206c6d8b3ed73c0', '2024-03-04 15:26:08.126558');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (47, 'PCBD', 'pcbd', '3984beb72179dad30d863d82945ef821e729ce83', '2024-03-06 15:04:14.401517');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (48, 'QGPC', 'qgpc', '493bde0539a21d455dca1b272ddc6d11e60b7711', '2024-03-06 15:04:19.289951');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (49, 'AMKL', 'amkl', '0d6f9de5a0b71a45204856e556e15c4483c7e5bd', '2024-03-06 15:04:21.307351');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (50, 'SNHW', 'snhw', 'ade20ea6b763c2ca820d2994f8527c1e4cbbec65', '2024-03-10 17:07:38.517787');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (51, 'DZIZ', 'dziz', 'dc29b35997e95368228305af457d7c427aa53037', '2024-03-10 17:39:57.698772');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (52, 'GXRE', 'gxre', 'cb220c74673746a0bf8c713bbd8ea04a054e4cee', '2024-03-10 17:39:59.542128');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (53, 'KTQV', 'ktqv', 'b45ea7aee6a4497fe24ba21396100b184b453492', '2024-03-10 18:50:10.141038');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (54, 'QNBA', 'qnba', '67a82a2638402cfd15e3773285abf27e6b193b6e', '2024-03-10 18:55:56.806052');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (55, 'DIAE', 'diae', 'ae1270b0bcc35fe751591aabc2c7c71b4d0f92a3', '2024-03-10 18:58:07.790388');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (56, 'QYLS', 'qyls', 'f7d9dad4926ab3f65b083a83a639e392e6fcbc94', '2024-03-10 18:58:21.514194');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (57, 'WUJS', 'wujs', '4a811726b9966b12cb9d22c54046d9641a6c74dc', '2024-03-10 18:58:31.741328');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (58, 'XZFW', 'xzfw', '1006cd11a5beb1403cc5049b2eae9d49ddf974dd', '2024-03-10 18:58:36.929266');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (59, 'IGYT', 'igyt', '26281c654aebda6dd470e0c72395690a6af74744', '2024-03-10 18:58:40.769534');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (60, 'TYKQ', 'tykq', 'b7295289e6a95bc6f7a08bb300ed406f64ce1294', '2024-03-10 18:58:44.799758');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (61, 'XDFM', 'xdfm', '210e22558a1015b8850638f84aabe51b18416346', '2024-03-10 19:08:58.756688');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (62, 'BGEJ', 'bgej', '4f1071bf87f9bb7647615bdf98bf3504f82685c1', '2024-03-11 09:03:16.458652');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (63, 'BIAT', 'biat', 'fb303bed902c520502fd7cbfac7aae95dc96a9bc', '2024-03-11 09:05:41.707200');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (64, 'GOYR', 'goyr', 'd76c583ce17e48d08e601d8ec3f990f117fa4319', '2024-03-11 09:06:22.507311');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (65, 'KYOA', 'kyoa', '7257c7ef68902c8987a0bf0d678018f6ebeb7b59', '2024-03-11 09:06:39.314615');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (66, 'YXOF', 'yxof', 'f7f39dab93173e22d0cd7b54e93140cdca5a5ad2', '2024-03-11 09:33:31.985096');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (67, 'VPIE', 'vpie', '158968b160f93d3927b9144a34e0ef9d6240a30b', '2024-03-12 22:21:01.824793');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (68, 'WITQ', 'witq', 'cb85dff10fcefd0247da180fe56a22ccb3f9edb3', '2024-03-12 22:24:29.168023');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (69, 'TMVW', 'tmvw', '69894a3a67c2febd227f6443fe4f8a9c33e07ca8', '2024-03-12 22:24:33.043873');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (70, 'BJBM', 'bjbm', '9373087846a767bbf6a5ad6513dae96e889ed4e4', '2024-03-12 22:25:36.535025');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (71, 'CDRT', 'cdrt', '39db922854fcb6f301b55b9c2b5c6721974f9ae2', '2024-03-12 22:26:09.837076');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (72, 'HSFG', 'hsfg', 'ac69cb7aeb7ac580b8724f733733c0ad6580fac4', '2024-05-31 23:42:05.287408');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (73, 'UBKM', 'ubkm', '7ea65648098f385e3f185109b3a78879276ec011', '2024-10-14 15:31:25.665143');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (74, 'RBRJ', 'rbrj', '28802573dd9fb2e0dc83c59fbb1657ab261d9aef', '2024-10-14 15:32:20.927113');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (75, 'JUXL', 'juxl', '3a79746395e483fd3fd9493249d00f8e1332f29c', '2024-10-14 15:32:52.637007');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (76, 'NCAK', 'ncak', 'b1a29bf9904efe3546386352f6437f204456f017', '2025-03-26 21:20:27.678792');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (77, 'WLFG', 'wlfg', '37db4e4a5db654e943a0004e6953cf201bbfb6f7', '2025-03-26 21:20:57.411590');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (78, 'QZGF', 'qzgf', '355fb8c252612c96ff532be51b615d1b52f8ce35', '2025-03-26 21:20:58.613992');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (79, 'HKPC', 'hkpc', '1eaba64cc0b4a78782895dbb2f0ebc6baa53f08e', '2025-03-26 21:21:39.304689');
INSERT INTO `captcha_captchastore` (`id`, `challenge`, `response`, `hashkey`, `expiration`) VALUES (80, 'QQPJ', 'qqpj', '597d172596d9e00b3bc3f5b7cc9b62f7adc8272c', '2025-03-26 21:26:22.819714');
COMMIT;

-- ----------------------------
-- Table structure for django_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `django_admin_log`;
CREATE TABLE `django_admin_log` (
  `id` int NOT NULL AUTO_INCREMENT,
  `action_time` datetime(6) NOT NULL,
  `object_id` longtext,
  `object_repr` varchar(200) NOT NULL,
  `action_flag` smallint unsigned NOT NULL,
  `change_message` longtext NOT NULL,
  `content_type_id` int DEFAULT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
  KEY `django_admin_log_user_id_c564eba6_fk_auth_app_user_id` (`user_id`),
  CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
  CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_app_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_app_user` (`id`),
  CONSTRAINT `django_admin_log_chk_1` CHECK ((`action_flag` >= 0))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_admin_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for django_content_type
-- ----------------------------
DROP TABLE IF EXISTS `django_content_type`;
CREATE TABLE `django_content_type` (
  `id` int NOT NULL AUTO_INCREMENT,
  `app_label` varchar(100) NOT NULL,
  `model` varchar(100) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_content_type
-- ----------------------------
BEGIN;
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (1, 'admin', 'logentry');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (3, 'auth', 'group');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (2, 'auth', 'permission');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (6, 'auth_app', 'user');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (7, 'captcha', 'captchastore');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (4, 'contenttypes', 'contenttype');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (8, 'it_app', 'article');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (11, 'it_app', 'collect');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (14, 'it_app', 'comment');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (12, 'it_app', 'follow');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (13, 'it_app', 'message');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (9, 'it_app', 'notice');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (10, 'it_app', 'type');
INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES (5, 'sessions', 'session');
COMMIT;

-- ----------------------------
-- Table structure for django_migrations
-- ----------------------------
DROP TABLE IF EXISTS `django_migrations`;
CREATE TABLE `django_migrations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `app` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `applied` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_migrations
-- ----------------------------
BEGIN;
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (1, 'contenttypes', '0001_initial', '2024-03-04 10:35:39.549747');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (2, 'contenttypes', '0002_remove_content_type_name', '2024-03-04 10:35:39.583866');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (3, 'auth', '0001_initial', '2024-03-04 10:35:39.722440');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (4, 'auth', '0002_alter_permission_name_max_length', '2024-03-04 10:35:39.750177');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (5, 'auth', '0003_alter_user_email_max_length', '2024-03-04 10:35:39.754520');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (6, 'auth', '0004_alter_user_username_opts', '2024-03-04 10:35:39.757586');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (7, 'auth', '0005_alter_user_last_login_null', '2024-03-04 10:35:39.761145');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (8, 'auth', '0006_require_contenttypes_0002', '2024-03-04 10:35:39.763374');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (9, 'auth', '0007_alter_validators_add_error_messages', '2024-03-04 10:35:39.767911');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (10, 'auth', '0008_alter_user_username_max_length', '2024-03-04 10:35:39.772850');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (11, 'auth', '0009_alter_user_last_name_max_length', '2024-03-04 10:35:39.776536');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (12, 'auth', '0010_alter_group_name_max_length', '2024-03-04 10:35:39.785760');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (13, 'auth', '0011_update_proxy_permissions', '2024-03-04 10:35:39.791137');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (14, 'auth', '0012_alter_user_first_name_max_length', '2024-03-04 10:35:39.795525');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (15, 'auth_app', '0001_initial', '2024-03-04 10:35:39.969829');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (16, 'admin', '0001_initial', '2024-03-04 10:35:40.043558');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (17, 'admin', '0002_logentry_remove_auto_add', '2024-03-04 10:35:40.052282');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (18, 'admin', '0003_logentry_add_action_flag_choices', '2024-03-04 10:35:40.056306');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (19, 'captcha', '0001_initial', '2024-03-04 10:35:40.071381');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (20, 'captcha', '0002_alter_captchastore_id', '2024-03-04 10:35:40.075008');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (21, 'it_app', '0001_initial', '2024-03-04 10:35:40.312119');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (22, 'sessions', '0001_initial', '2024-03-04 10:35:40.334795');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (23, 'auth_app', '0002_user_sex', '2024-03-04 11:59:34.326285');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (24, 'it_app', '0002_collect_is_read_follow_is_read_message_is_read_and_more', '2024-03-05 03:13:51.571479');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (25, 'it_app', '0003_article_summary', '2024-03-05 10:31:13.397748');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (26, 'it_app', '0004_article_user', '2024-03-06 00:47:22.652747');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (27, 'it_app', '0005_notice_is_show', '2024-03-07 16:38:30.373813');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (28, 'it_app', '0006_message_title', '2024-03-08 15:37:47.656411');
INSERT INTO `django_migrations` (`id`, `app`, `name`, `applied`) VALUES (29, 'it_app', '0007_comment', '2024-03-10 22:45:55.151773');
COMMIT;

-- ----------------------------
-- Table structure for django_session
-- ----------------------------
DROP TABLE IF EXISTS `django_session`;
CREATE TABLE `django_session` (
  `session_key` varchar(40) NOT NULL,
  `session_data` longtext NOT NULL,
  `expire_date` datetime(6) NOT NULL,
  PRIMARY KEY (`session_key`),
  KEY `django_session_expire_date_a5c62663` (`expire_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of django_session
-- ----------------------------
BEGIN;
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('7kalt80slqg0l60gyx6vwkzi12r1swdu', '.eJytlEtOwzAQhq9SZV1a27FjlyV7TkBQNH6kNaRxFScChHp3PA0LonbR0K5mMvNnHp8tf2cVDP2uGqLrKm-zx4xmy78xDebdtZiwb9Buw8qEtu-8XqFk9ZuNq-dgXfP0q50U2EHcpb8dr52gQlMqHd3UG26lVYwaW2wY5zkYornaKMWJIIWSIqfWWSOVYgWTLGdYdO_aIaZaL99lBodDmT0uysz31clfJr-FvRujZTkIRopkpJEajQaKhqfgSevTIqO2hocYGm8XydHhc0wPXTNm12DX_dfBNT726zGnOwfWdMNeR9TgOHfqfHxFQfXh_HbXo4bgt_MWfUoIPS4Xf5ffhmDjhd0LoST2BEdmTACdScd4YX_oem-aOQhuG-AMA51iYFdiELQwaDiHe2BoQ8Iw6yLc1P-MAptSyK-kIE19uofO1ngyVik0pKj_R2HvYoTtHAy3DXCGIZ9i4NdiEOzUl-Xy-sMwjT_oAJ19wH0v0MA3bg6KewxxRoRPiYjja3b8Ae-z0QM:1rjUZ2:iuBzv1rakDlOGvjiWCS3lDwqRb6fORhhakMXgfiBokE', '2024-03-25 09:34:52.701711');
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('ez69e6q9f2jv4rc9fle6bm8o2brs5t8k', '.eJytlEtOwzAQhq9SZV1a27FjlyV7TkBQNH6kNaRxFScChHp3PA0LonbR0K5mMvNnHp8tf2cVDP2uGqLrKm-zx4xmy78xDebdtZiwb9Buw8qEtu-8XqFk9ZuNq-dgXfP0q50U2EHcpb8dr52gQlMqHd3UG26lVYwaW2wY5zkYornaKMWJIIWSIqfWWSOVYgWTLGdYdO_aIaZaL99lBodDmT0uysz31clfJr-FvRujZTkIRopkpJEajQaKhqfgSevTIqO2hocYGm8XydHhc0wPXTNm12DX_dfBNT726zGnOwfWdMNeR9TgOHfqfHxFQfXh_HbXo4bgt_MWfUoIPS4Xf5ffhmDjhd0LoST2BEdmTACdScd4YX_oem-aOQhuG-AMA51iYFdiELQwaDiHe2BoQ8Iw6yLc1P-MAptSyK-kIE19uofO1ngyVik0pKj_R2HvYoTtHAy3DXCGIZ9i4NdiEOzUl-Xy-sMwjT_oAJ19wH0v0MA3bg6KewxxRoRPiYjja3b8Ae-z0QM:1t0Fi5:Pyj9v8ZmVS1UIj_J4GDRPPCvd54MF2babYMLf6RQ3pE', '2024-10-28 15:41:45.859163');
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('mde4eshue6id24ihncptdijtbsz4li8y', '.eJytlEtOwzAQhq9SZV1a27FjlyV7TkBQNH6kNaRxFScChHp3PA0LonbR0K5mMvNnHp8tf2cVDP2uGqLrKm-zx4xmy78xDebdtZiwb9Buw8qEtu-8XqFk9ZuNq-dgXfP0q50U2EHcpb8dr52gQlMqHd3UG26lVYwaW2wY5zkYornaKMWJIIWSIqfWWSOVYgWTLGdYdO_aIaZaL99lBodDmT0uysz31clfJr-FvRujZTkIRopkpJEajQaKhqfgSevTIqO2hocYGm8XydHhc0wPXTNm12DX_dfBNT726zGnOwfWdMNeR9TgOHfqfHxFQfXh_HbXo4bgt_MWfUoIPS4Xf5ffhmDjhd0LoST2BEdmTACdScd4YX_oem-aOQhuG-AMA51iYFdiELQwaDiHe2BoQ8Iw6yLc1P-MAptSyK-kIE19uofO1ngyVik0pKj_R2HvYoTtHAy3DXCGIZ9i4NdiEOzUl-Xy-sMwjT_oAJ19wH0v0MA3bg6KewxxRoRPiYjja3b8Ae-z0QM:1rk3he:MqdXAPGp7DK6souvl7xI-rZzW4Yys2GhbR78Dij8zGw', '2024-03-26 23:06:06.946404');
INSERT INTO `django_session` (`session_key`, `session_data`, `expire_date`) VALUES ('yp8p3ildcjkovr3n5glf77y6vuz6o8op', '.eJytlEtOwzAQhq9SZV1a27FjlyV7TkBQNH6kNaRxFScChHp3PA0LonbR0K5mMvNnHp8tf2cVDP2uGqLrKm-zx4xmy78xDebdtZiwb9Buw8qEtu-8XqFk9ZuNq-dgXfP0q50U2EHcpb8dr52gQlMqHd3UG26lVYwaW2wY5zkYornaKMWJIIWSIqfWWSOVYgWTLGdYdO_aIaZaL99lBodDmT0uysz31clfJr-FvRujZTkIRopkpJEajQaKhqfgSevTIqO2hocYGm8XydHhc0wPXTNm12DX_dfBNT726zGnOwfWdMNeR9TgOHfqfHxFQfXh_HbXo4bgt_MWfUoIPS4Xf5ffhmDjhd0LoST2BEdmTACdScd4YX_oem-aOQhuG-AMA51iYFdiELQwaDiHe2BoQ8Iw6yLc1P-MAptSyK-kIE19uofO1ngyVik0pKj_R2HvYoTtHAy3DXCGIZ9i4NdiEOzUl-Xy-sMwjT_oAJ19wH0v0MA3bg6KewxxRoRPiYjja3b8Ae-z0QM:1txQn2:3pLYYIRyOa7P7dKfYyUkmooFKpYOWmVfbjjCjBo44_4', '2025-04-09 21:27:28.189265');
COMMIT;

-- ----------------------------
-- Table structure for it_app_article
-- ----------------------------
DROP TABLE IF EXISTS `it_app_article`;
CREATE TABLE `it_app_article` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `cover` varchar(200) DEFAULT NULL,
  `tag` varchar(1000) DEFAULT NULL,
  `status` int NOT NULL,
  `rang` int NOT NULL,
  `examine` int NOT NULL,
  `readers` int NOT NULL,
  `content` longtext,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `type_id` bigint DEFAULT NULL,
  `summary` varchar(500) DEFAULT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `it_app_article_type_id_508f648a_fk_it_app_type_id` (`type_id`),
  KEY `it_app_article_user_id_9db79e60_fk_auth_app_user_id` (`user_id`),
  CONSTRAINT `it_app_article_type_id_508f648a_fk_it_app_type_id` FOREIGN KEY (`type_id`) REFERENCES `it_app_type` (`id`),
  CONSTRAINT `it_app_article_user_id_9db79e60_fk_auth_app_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_app_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of it_app_article
-- ----------------------------
BEGIN;
INSERT INTO `it_app_article` (`id`, `title`, `cover`, `tag`, `status`, `rang`, `examine`, `readers`, `content`, `create_time`, `update_time`, `type_id`, `summary`, `user_id`) VALUES (29, 'window Install MySQL', 'a4757f07-381e-4b56-a103-955afeeb02f9.png', 'mysql', 1, 1, 0, 7, '# Download mysql\n1. Install\n2. Init Password', '2024-03-11 09:07:16.939746', '2025-03-26 21:25:01.634333', 3, 'window Install MySQL', 2);
INSERT INTO `it_app_article` (`id`, `title`, `cover`, `tag`, `status`, `rang`, `examine`, `readers`, `content`, `create_time`, `update_time`, `type_id`, `summary`, `user_id`) VALUES (31, '我的草稿文章', NULL, NULL, 2, 1, 0, 13, '阿斯顿发送到', '2024-03-12 22:26:07.342177', '2024-03-12 22:40:31.855917', NULL, '', 1);
INSERT INTO `it_app_article` (`id`, `title`, `cover`, `tag`, `status`, `rang`, `examine`, `readers`, `content`, `create_time`, `update_time`, `type_id`, `summary`, `user_id`) VALUES (32, '我的博客', NULL, NULL, 2, 1, 0, 0, '# 我的第一篇博客\n|column1|column2|column3|\n|-|-|-|\n|content1|content2|content3|', '2024-10-14 15:32:29.034336', '2024-10-14 15:32:53.903275', NULL, '', 1);
COMMIT;

-- ----------------------------
-- Table structure for it_app_collect
-- ----------------------------
DROP TABLE IF EXISTS `it_app_collect`;
CREATE TABLE `it_app_collect` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `article_id` bigint NOT NULL,
  `user_id` bigint NOT NULL,
  `is_read` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `it_app_collect_article_id_0eb119b3_fk_it_app_article_id` (`article_id`),
  KEY `it_app_collect_user_id_9e63d66d_fk_auth_app_user_id` (`user_id`),
  CONSTRAINT `it_app_collect_article_id_0eb119b3_fk_it_app_article_id` FOREIGN KEY (`article_id`) REFERENCES `it_app_article` (`id`),
  CONSTRAINT `it_app_collect_user_id_9e63d66d_fk_auth_app_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_app_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of it_app_collect
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for it_app_comment
-- ----------------------------
DROP TABLE IF EXISTS `it_app_comment`;
CREATE TABLE `it_app_comment` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `content` varchar(1000) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `article_id` bigint NOT NULL,
  `parent_comment_id` bigint DEFAULT NULL,
  `user_id` bigint NOT NULL,
  PRIMARY KEY (`id`),
  KEY `it_app_comment_article_id_84720362_fk_it_app_article_id` (`article_id`),
  KEY `it_app_comment_parent_comment_id_63d0b1b7_fk_it_app_comment_id` (`parent_comment_id`),
  KEY `it_app_comment_user_id_9ae7e7c5_fk_auth_app_user_id` (`user_id`),
  CONSTRAINT `it_app_comment_article_id_84720362_fk_it_app_article_id` FOREIGN KEY (`article_id`) REFERENCES `it_app_article` (`id`),
  CONSTRAINT `it_app_comment_parent_comment_id_63d0b1b7_fk_it_app_comment_id` FOREIGN KEY (`parent_comment_id`) REFERENCES `it_app_comment` (`id`),
  CONSTRAINT `it_app_comment_user_id_9ae7e7c5_fk_auth_app_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_app_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of it_app_comment
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for it_app_follow
-- ----------------------------
DROP TABLE IF EXISTS `it_app_follow`;
CREATE TABLE `it_app_follow` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `being_followed_id` bigint NOT NULL,
  `follower_id` bigint NOT NULL,
  `is_read` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `it_app_follow_being_followed_id_5413ac8a_fk_auth_app_user_id` (`being_followed_id`),
  KEY `it_app_follow_follower_id_b6bb5b0b_fk_auth_app_user_id` (`follower_id`),
  CONSTRAINT `it_app_follow_being_followed_id_5413ac8a_fk_auth_app_user_id` FOREIGN KEY (`being_followed_id`) REFERENCES `auth_app_user` (`id`),
  CONSTRAINT `it_app_follow_follower_id_b6bb5b0b_fk_auth_app_user_id` FOREIGN KEY (`follower_id`) REFERENCES `auth_app_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of it_app_follow
-- ----------------------------
BEGIN;
INSERT INTO `it_app_follow` (`id`, `create_time`, `update_time`, `being_followed_id`, `follower_id`, `is_read`) VALUES (12, '2024-03-10 19:03:32.751718', '2024-03-10 19:03:32.751806', 1, 1, 1);
INSERT INTO `it_app_follow` (`id`, `create_time`, `update_time`, `being_followed_id`, `follower_id`, `is_read`) VALUES (14, '2024-03-11 09:33:37.038015', '2024-03-11 09:33:37.038085', 1, 2, 1);
COMMIT;

-- ----------------------------
-- Table structure for it_app_message
-- ----------------------------
DROP TABLE IF EXISTS `it_app_message`;
CREATE TABLE `it_app_message` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `content` varchar(1000) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `user_id` bigint NOT NULL,
  `is_read` int NOT NULL,
  `title` varchar(200) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `it_app_message_user_id_1057af87_fk_auth_app_user_id` (`user_id`),
  CONSTRAINT `it_app_message_user_id_1057af87_fk_auth_app_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_app_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of it_app_message
-- ----------------------------
BEGIN;
INSERT INTO `it_app_message` (`id`, `content`, `create_time`, `update_time`, `user_id`, `is_read`, `title`) VALUES (2, 'This is a push for the administrator', '2025-03-26 21:28:59.585824', '2025-03-26 21:28:59.594023', 1, 1, 'This is a push for the administrator');
COMMIT;

-- ----------------------------
-- Table structure for it_app_notice
-- ----------------------------
DROP TABLE IF EXISTS `it_app_notice`;
CREATE TABLE `it_app_notice` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `title` varchar(50) NOT NULL,
  `content` varchar(1000) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  `is_show` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of it_app_notice
-- ----------------------------
BEGIN;
INSERT INTO `it_app_notice` (`id`, `title`, `content`, `create_time`, `update_time`, `is_show`) VALUES (1, 'The IT community is online!', 'The IT community is online!Come On!', '2024-03-07 16:42:31.958519', '2024-03-07 16:42:31.964306', 1);
COMMIT;

-- ----------------------------
-- Table structure for it_app_type
-- ----------------------------
DROP TABLE IF EXISTS `it_app_type`;
CREATE TABLE `it_app_type` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `create_time` datetime(6) NOT NULL,
  `update_time` datetime(6) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of it_app_type
-- ----------------------------
BEGIN;
INSERT INTO `it_app_type` (`id`, `name`, `create_time`, `update_time`) VALUES (1, 'Front', '2024-03-04 11:37:25.265728', '2024-03-04 11:37:25.284452');
INSERT INTO `it_app_type` (`id`, `name`, `create_time`, `update_time`) VALUES (3, 'Database', '2024-03-04 11:37:37.385675', '2024-03-04 11:37:37.388409');
INSERT INTO `it_app_type` (`id`, `name`, `create_time`, `update_time`) VALUES (4, 'Back', '2024-03-04 11:38:35.011616', '2024-03-04 11:38:35.016785');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
